[QUIZ] Check your understanding of SQL - Part 2

Continue series What do you know about SQL? , part 2 continues with questions that revolve around basic knowledge in databases.

  1. Question 1: In SQL, how to insert a new record into the "Persons" table?
    1. INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
    2. INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
    3. INSERT ('Jimmy', 'Jackson') INTO Persons
  2. Question 2: In SQL, how to insert the record "LastName" worth "Olsen" in the "Persons" table?
    1. INSERT ('Olsen') INTO Persons (LastName)
    2. INSERT INTO Persons ('Olsen') INTO LastName
    3. INSERT INTO Persons (LastName) VALUES ('Olsen')
  3. Question 3: How to change "Hansen" to "Nilsen" in the "LastName" column in the "Persons" table?
    1. MODIFY Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'
    2. UPDATE Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'
    3. MODIFY Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen
    4. UPDATE Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen'
  4. Question 4: In SQL, how to delete the "Peter" record from the "FirstName" column in the "Persons" table?
    1. DELETE FirstName = 'Peter' FROM Persons
    2. DELETE ROW FirstName = 'Peter' FROM Persons
    3. DELETE FROM Persons WHERE FirstName = 'Peter'
  5. Question 5: In SQL, how to return the number of records in the "Persons" table?
    1. SELECT COLUMNS (*) FROM Persons
    2. SELECT COUNT (*) FROM Persons
    3. SELECT LEN (*) FROM Persons
    4. SELECT NO (*) FROM Persons
  6. Question 6: Where is the most popular type of JOIN?
    1. INNER JOIN
    2. INSIDE JOIN
    3. JOINED TABLE
    4. JOINED
  7. Question 7: Which operator is used to retrieve data in a range?
    1. RANGE
    2. BETWEEN
    3. WITHIN
  8. Question 8: The NOT NULL constraint does not accept a null value column.
    1. It's correct
    2. False
  9. Question 9: Which clauses are used to find values ​​according to certain patterns?
    1. LIKE
    2. GET
    3. FROM
  10. Question 10: Which SQL statement is used to create the table in the database?
    1. CREATE DB
    2. CREATE TABLE
    3. CREATE DATABASE TAB
    4. CREATE DATABASE TABLE
Update 24 May 2019
learn sqldatabasesql quizzesdatabase testquiz sqlcheck sqlsql knowledgesql testsql exercises

You should read it

Maybe you are interested

Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile